|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Companion Qube
|
Posted - 2010.04.22 01:52:00 -
[1]
Originally by: Hel O'Ween Version 2.0.6 has been released, along with a database update (15).
This version adds a new feature I called "Virtual Character" (VC) to EWA. You combine two or more of your existing (real) charaters into a virtual character. This VC will then act as an "on-the-fly-total" of the combined chars.
In order for this to work, you need to apply both the appliaction and the database update.
Virtual characters can be created/edited via menu Extras -> Virtual character.
As always, see the version history for the changes in this version.
This is kind of ridiculous, I was going to post and ask for the functional equivalent of this today. Get out of my head
Also, thanks
|
Companion Qube
|
Posted - 2010.04.23 19:20:00 -
[2]
Edited by: Companion Qube on 23/04/2010 19:26:35 Just found a simple bug with the quick briefing's chart - if you have a day with no buy/sell activity (none at all) instead of charting a zero the chart component ignores the point entirely and shifts later data-points one day to the left.
http://img406.imageshack.us/img406/2949/chart01.jpg
Note the empty sales value on 4-18 - this causes the sell graph to ignore that day and shift all futher points one to the left.
http://img153.imageshack.us/img153/509/chart02.jpg
This is more obvious, it's kind of funny once you figure out what you're looking at.
|
Companion Qube
|
Posted - 2010.04.23 22:24:00 -
[3]
Originally by: Tehg Rhind I just wanted to say how good your app is and how much I appreciate it. I started using it just as a way to update my personal database, but as time goes on and you expand your functionality I am starting to use my own database less and less. After the tyrannis changes I may completely retire my database.
A thought. Some items are bought, not to be resold, but either to melt down or to value add through industry. Do you have any intentions to add functionality to work better with those features? I'm not sure how hard it would be, but here's my thoughts on how it could work (without making a full fledged industrial app). Items could be identified by the user as being either input or output, and after subtracting out any surplus that might be resold you could group them as such in a balance sheet.
You could have the user define subgroups as well. Like say minerals vs ships/modules and salvage goods vs rigs. Leave the worrying about blueprint quantities to the user. They could theorhetically get very fine details based on their subgroups (like armor rigs) but that would be up to them.
Or just what i said at first, 2 large groups (input and output). I know some of the industrial apps do this better, but their financial tools are simply terrible.
|
Companion Qube
|
Posted - 2010.04.24 02:36:00 -
[4]
Hmm, I have a feature request, I'd like to see a third option in addition to "Corp Data" and "Personal Data." Something along the lines of "All Data" - a combination of corp and personal. I'm willing to start a bounty pool if the feature interests you, I've been using EWA long enough that I should probably send you some isk anyway.
|
Companion Qube
|
Posted - 2010.04.24 10:45:00 -
[5]
Originally by: Hel O'Ween @Companion:
My first impression is: this sounds like it could easily be done. But the devil is in the details (does this make sense in English? It's a German proverb ...), so let me have a look at it first.
Totally reasonable, I've done enough software development and technical work to know this too well.
Originally by: Hel O'Ween Oh, and no "bounty" required. I do accept donations, of course. But I never added something because someone paid for it and I don't intend to do so. This keeps me independent to take EWA the way I want, without the need to carry that paid for feature around although it might be outdated or just a PITA to maintain.
You can't blame me for trying to bribe you
|
Companion Qube
|
Posted - 2010.04.26 07:59:00 -
[6]
Originally by: C Melindy first off, i would like to say that I really enjoy using this program. It shows me alot of info, as well as easy to use. But one question is, in the quick briefing, what is the difference between Wallet Transaction and Wallet Journal.
Transactions show you what you've bought and sold, at face value - they don't show losses due to taxes and fees.
The journal shows all wallet in/out data, but in no greater detail than "market escrow authorized" or "xxx bought from yyy."
tl;dr- the journal shows all in/out data including taxes, fees, insurance, bounties, rent, etc. while the wallet only shows buy and sell data.
|
Companion Qube
|
Posted - 2010.07.23 21:21:00 -
[7]
Hey Hel,
I remember you mentioned something about the auto-downloader having issues - is it usable again? If it's not I have a feature request, a "download all" button or something similar so we can one-click grab data from all of our accounts.
CQ
|
Companion Qube
|
Posted - 2010.07.29 23:49:00 -
[8]
Great news, thanks a lot
|
Companion Qube
|
Posted - 2010.08.26 17:27:00 -
[9]
Hey Hel,
Is it possible that you could make asset updates via the autodownloader optional? I use jeveassets frequently and I'm often finding that the autodownloader has blown my download for the day.
CQ
|
Companion Qube
|
Posted - 2010.08.26 23:51:00 -
[10]
And therein lies the beauty of leaving the autodownloader running 23/7 - you can easily keep track of all of your historical trade data.
|
|
Companion Qube
|
Posted - 2010.08.31 20:49:00 -
[11]
Originally by: Hel O'Ween
Originally by: Companion Qube
Is it possible that you could make asset updates via the autodownloader optional?
You might want to have a look at the new version (1.0.8) ...
Awesome, thanks!
|
Companion Qube
|
Posted - 2010.09.17 20:32:00 -
[12]
Originally by: Hel O'Ween
Quote:
2 - Allow customization of the tables in terms of ordering the columns, column sizes, removing columns, sorting columns. I know you can currently resize and sort - but the settings don't save and i have to do it each time. It'd be very helpful to have it start up on the report format i like to use.
... while this sounds - if not completely undoable - at least like a major PITA.
OK, column sizes, removing & columns sorting (and persisting those states) might work in theory. But that would require some heavy coding.
Ordering columns wouldn't work on many grids, as it would break the grid's logic. The outcome would be funny, as calculating totals, counts, averages is done by the grid, based on changes in the cells contents from left to right. So, if you move "Location" to the first column, the total would be calculated on the column Price, not Total.
Anyhow - let's see if I experience one of those rare "genius moments" and figure out how to implement a bit of the above.
Most, if not all, of these features are implemented in the default grid components that .net uses. I know you were thinking (long term) of trying to move more in that direction, I'd just let that hang until you do.
Speaking of .net, would you mind putting up the current source for the autodownloader? I'm interested in porting it to .net.
|
Companion Qube
|
Posted - 2010.10.20 07:35:00 -
[13]
Originally by: Warren Chest Thanks for this great app, I use it fo two years and it is very useful.
Last week, when retreiving datas from the API, I found something strange : the transactions for my corp did not appeared. The datas are correct in the journal or the personal ones but not the transactions for the corp ! Nothing was added since 10th october in the corporation wallet transaction table ...
Does anybody has this problem ?
Under extras > maintenance try compacting the database. I've had weird problems like this before, usually from something leaving the DB in a strange state (power outage while running EWAAutoData, etc) - for whatever reason compacting has always fixed things.
|
Companion Qube
|
Posted - 2010.10.27 05:39:00 -
[14]
How do I go about emptying the log with a direct database query? I have something like 1 and a half years of heavy trading and I've never cleared the log - loading the log causes EWA to try and load everything into memory, which does bad things.
|
Companion Qube
|
Posted - 2010.10.28 00:16:00 -
[15]
Thanks, that cleaned things up nicely. You might appreciate this.
|
Companion Qube
|
Posted - 2010.10.28 11:47:00 -
[16]
The DB was actually one of the single largest files on my SSD so I'd been monitoring it for a while - I'm pretty surprised that was all log entries though. I expected more was data.
|
Companion Qube
|
Posted - 2010.12.21 07:57:00 -
[17]
Edited by: Companion Qube on 21/12/2010 07:57:22 I'm seeing a lot of this in the logs - spammed even, to the tune of hundreds of megabytes or gigabytes worth of log output over a day or so. Halp :(
Date/Time: 12/20/2010 8:18:56 AM EventID : 1001 Event : ApplicationError ----- cXMLCacheFile:Save->-2147467259, Microsoft JET Database Engine, Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. ==================================================================================================== Date/Time: 12/20/2010 8:18:56 AM EventID : 105 Event : DBError ----- Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. ====================================================================================================
edit: RIP. forum formatting.
|
Companion Qube
|
Posted - 2010.12.21 11:14:00 -
[18]
Yeah, honestly I'm lazy enough that I've been avoiding this for two or three months. I'm willing to blow away anything except the 18 months of EWA database that I've got stored, any suggestions?
|
Companion Qube
|
Posted - 2010.12.23 05:05:00 -
[19]
Just a quick update, I think I fixed the problem. I guessed that something crashed the machine while wallet aware was writing to the database (good old lack of atomic commits) - so I googled for info re: repairing JET databases. Installing access off my office disk and running compact/repair on the database fixed things right up, no need to export/import.
|
Companion Qube
|
Posted - 2010.12.23 10:54:00 -
[20]
Yeah, I did - it roasted the 1.5gb of cached db calls and extra log data but didn't fix the underlying structural problem. Sorry for the false alarm, once I turned my brain back on and read the log it wasn't too hard to fix.
|
|
Companion Qube
|
Posted - 2011.01.13 06:48:00 -
[21]
One more quick win7 thing - on shutdown EWA auto updater doesn't seem to be closing itself down properly unless it's already paused. I've seen this trying to close down manually too, the program needs to be paused before it will exit cleanly. If the shutdown signal is sent without pausing first then the program switches into paused state but doesn't close.
You might be able to hack around it by just running the code in the shutdown event handler twice.
|
Companion Qube
|
Posted - 2011.01.22 08:47:00 -
[22]
Hey Hel- I noticed a possible problem, I'm only showing one character in the wallet stats grid of the auto updater after grabbing the new version. I checked under options, all of my characters are listed and set to pull data.
|
Companion Qube
|
Posted - 2011.01.22 10:40:00 -
[23]
Edited by: Companion Qube on 22/01/2011 10:44:37 Ahhh, I figured it out. If there are any deleted characters still in EWA's database it'll cause the auto-downloader to choke and stop pulling records when it hits their entry. The second character polled was a deleted alt. Seems to be working fine now.
|
Companion Qube
|
Posted - 2011.02.01 05:30:00 -
[24]
I know you love hearing from me, but uh, I've broken something again.
Check this out: http://img441.imageshack.us/img441/7641/notreally19b.jpg
I definitely didn't make 28b over 10 days, if I had to guess it was more like 5-7b. Some context, I have a virtual character setup to give me an overview of all personal and corp transactions, basically a single master cashflow statement. Somehow something isn't accounted for and I'm over-reporting profit. I'm a bit confused to be honest, everything I've done across my accounts should be summarized there.
I have a hunch that +7b in the corp wallet is accurate, the +19b in the personal wallet is probably noise.
Any thoughts?
|
Companion Qube
|
Posted - 2011.02.01 17:48:00 -
[25]
Edited by: Companion Qube on 01/02/2011 18:10:42
Originally by: Hel O'Ween
Any idea which of the figures is wrong? The suspects seem to be the "big three": Corporation Account Withdrawl, Market Escrow, Market Transaction.
It might have something to do with the recent change to the Wallet Journal API. My adaption might be flawed, but I'm not sure where to look at.
I think it missed a player donation to the corp wallet for ~30b. Player donations between the two journals (corp & personal) should zero sum, but they don't.
It looks like something has gone wrong between one character and the corp wallet - I'm going to try grabbing the last 30 days of data for corp/char with an empty database and see what I get.
|
Companion Qube
|
Posted - 2011.02.01 21:37:00 -
[26]
Edited by: Companion Qube on 01/02/2011 21:40:20
Originally by: teppo3345345 ...
It might be too late to suggest this, but an easy way to handle your situation would have been to add the new api info then setup a virtual character that encompassed both the old and new data. That's what I ended up doing to get a cashflow statement for all of my accounts and corps.
Hel- I backed up and moved my EWA database and polled data from the API again, this time the corp donations showed up as expected. Something is still weird through, the totals in EWA don't match up with what I see in game. I'm going to get a notepad and balance my in-game wallet and see if I can figure out where transactions are missing in EWA.
|
Companion Qube
|
Posted - 2011.02.02 21:00:00 -
[27]
How do I dump the raw xml for the corp & personal journal? If it's easier I'm happy to send you the full api key for the character in question.
|
Companion Qube
|
Posted - 2011.02.07 00:47:00 -
[28]
Just thought I'd report back - some days after I reported the missing journal data then API decided to cough it up. Everything balances again, but I'm not sure what changed :p
|
Companion Qube
Minmatar Electron Conservation Inc
|
Posted - 2011.02.07 21:01:00 -
[29]
I'm honestly not sure either. About 3 days after I noticed the problem it magically resolved itself. I kind of wonder if they broke the api after the most recent patch, then pushed out a fix without saying anything.
... drunkpoasting best poasting yo |
Companion Qube
Minmatar Electron Conservation Inc
|
Posted - 2011.03.20 11:39:00 -
[30]
Originally by: Hel O'Ween EWA version 2.0.22 has been released.
This update includes some administrative features, mainly
- Let you purge all data from within EWA, resetting EWA to a "fresh-installed" state (data-wise).
- If EWA can't find its database where it assumes it to be, EWA now lets you point it to the right DB location.
As always, see the version history for details.
Have I told you recently how much I appreciate the work you put in to this?
drunkpoasting best poasting |
|
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.05 00:55:00 -
[31]
Heya Hel
I have another feature request - would it be possible to have the application throw an error message (both the auto-downloader) and the main client when there's a problem accessing the database? I've had a few instances where my machine crashed (yay overclocking) and left the db in an unusable state until I repaired with access. This is the situation I've encountered a couple times:
==================================================================================================== Date/Time: 6/4/2011 5:45:57 PM EventID : 105 Event : DBError ----- Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. ==================================================================================================== Date/Time: 6/4/2011 5:45:57 PM EventID : 1001 Event : ApplicationError ----- cEVEWalletTransaction:Save->-2147467259, Microsoft JET Database Engine, Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
It would be nice to have a notification when that occurs without having to go to the log - I often will just leave the auto-downloader running for weeks at a time without really doing any analysis only to find that I've been doing nothing but generating error messages for 2 weeks.
cheers!
...they see me trollin', they hatin' ♥
|
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.05 15:52:00 -
[32]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 05/06/2011 14:02:18 Hey CQ, long time no hear.
You know the rule, you never hear from satisfied customers
...they see me trollin', they hatin' ♥
|
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.07 06:34:00 -
[33]
Originally by: Hel O'Ween
Originally by: Companion Qube You know the rule, you never hear from satisfied customers
Hmm, I thought this would be an easy fix. But as I was to about to add it, I realized that - due to the way the record adding/error logging stuff works in EWA - I would trigger a message box each single error (=each single record) = MASSIVE MESSAG BOX SPAM without you being able to stop it (except by killing the task).
This obviously needs some thinking ...
Ahh, I haven't looked at the internals - sorry to cause a bunch of work :(
Total non-sequitur, do you happen to code with python as well? I'm going to be doing some work over the summer with it that you might find interesting. I'll share when I'm in progress and the program isn't just talk
...they see me trollin', they hatin' ♥
|
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.16 22:45:00 -
[34]
Edited by: Companion Qube on 16/06/2011 22:48:52 Edited by: Companion Qube on 16/06/2011 22:46:51
Originally by: Hel O'Ween
Originally by: Companion Qube You know the rule, you never hear from satisfied customers
Hmm, I thought this would be an easy fix. But as I was to about to add it, I realized that - due to the way the record adding/error logging stuff works in EWA - I would trigger a message box each single error (=each single record) = MASSIVE MESSAG BOX SPAM without you being able to stop it (except by killing the task).
This obviously needs some thinking ...
Hmm, here's a one quick way to solve that (bad pseudocode follows)
global bool hackMsgBoxShown = false void resetFlag() { hackMsgBoxShown = false } void hackShowBox(string msg) { if hackMsgBoxShown return
hackMsgBoxShown = true msgbox.show(msg) ; bind resetFlag to the OK button }
Clearly not a "good" way to solve the problem, but a time effective one
This assumes that the box doesn't pause execution until the user presses OK, if it does .. then just reset the flag after the batch of DB work has been done and the boxes will be suppressed until then.
TBH I wish I could just patch this in and submit a diff to you, but VB6.... If I'm going to learn another language I'd rather not board the time machine to 1997
...they see me trollin', they hatin' ♥
|
|
|
|